2014-05-15 - 12893 - Service Request - MRP Job failing for some materials #ProductionBreakFix #mrpexecution #MRPPIR
2014-05-15 - 12893 - Service Request - MRP Job failing for some materials
Problem Summary
MRP job failing for few materials during normal mode with error duplicate entry. Investigate if there are any OSS notes available.
Admin Info
| Purpose |
MRP Job failing for some materials |
| Requested by |
Babu Lankipalli |
| Issue Date |
05-15-2014 |
| Resolved by |
Laxman |
| Resolved Date |
06-05-2014 |
| Document Status |
WIP |
Detailed Problem Description
(Include Screen Shots if required )It was observed that during daily MRP run for cut piece materais MRP terminations are there. Please find below screen shot of MRP termination with error.
Solution Analysis and Recommendations
(Include Screen Shots if required)
Observed that if we run the MRP in normal mode for the terminated materials with above error are going in to dump. Please find below screen shot of dump. If we run the MRP in delete and recreate mode ther no problem at all. To resolve this issue New Era advised to look for OSS notes if any. As a work around again running the MRP in delete and re-create mode for terminated materials with the above error. During search found below given OSS notes and checked for suitable for our version or not.
| OSS Notes Found |
Description |
Available in our version |
| 1267783 |
Dump SAPSQL ARRAY INSERT DUPREC in MRP |
Yes |
| 1259493 |
MRP gives duplicate records dump |
Yes |
| 1167501 |
Dump during MRP run SAPSQL_ARRAY_INSERT_DUPREC |
Yes |
| 1160867 |
Short dump in AFS MRP: SAPSQL_ARRAY_INSERT_DUPREC |
Yes |
| 1375653 |
Dump SAPSQL_ARRAY_INSERT_DUPREC in MRP |
Yes |
| 1422681 |
Dump SAPSQL_ARRAY_INSERT_DUPREC during MRP run for AFS Material |
Yes |
Since correction code of all the above said OSS note is available in our system advised client to escalate the issue to SAP to resolve the issue.
Release Information
Provide link here to Release Notes if Technical Objects were changed